CREATE TABLE [dbo].[u_segmento]
(
[Id] [int] NOT NULL,
[segmento] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[idLote] [int] NOT NULL,
[idCensista] [numeric] (10, 0) NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[u_segmento] ADD CONSTRAINT [PK_u_segmento] PRIMARY KEY CLUSTERED  ([Id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[u_segmento] WITH NOCHECK ADD CONSTRAINT [FK_u_segmento_u_lote] FOREIGN KEY ([idLote]) REFERENCES [dbo].[u_lote] ([Id]) NOT FOR REPLICATION
GO
ALTER TABLE [dbo].[u_segmento] NOCHECK CONSTRAINT [FK_u_segmento_u_lote]
GO
